﻿CREATE TABLE [dbo].[Quote_Tbl] (
    [QuoteID]            INT            IDENTITY (1, 1) NOT NULL,
    [Salesman]           NVARCHAR (50)  NULL,
    [FirstName]          NVARCHAR (50)  NULL,
    [LastName]           NVARCHAR (50)  NULL,
    [BoatType]           NVARCHAR (MAX) NULL,
    [BoatName]           NVARCHAR (MAX) NULL,
    [WorksOrderNumber]   NVARCHAR (50)  NULL,
    [LOA]                INT            NULL,
    [DeliveryWeek]       INT            NULL,
    [DateCreated]        NVARCHAR (50)  NULL,
    [MarketID]           INT            NULL,
    [I]                  REAL           NULL,
    [J]                  FLOAT          NULL,
    [P]                  FLOAT          NULL,
    [E]                  FLOAT          NULL,
    [CurrencyID]         INT            NULL,
    [BoatStyleID]        INT            NULL,
    [Address1]           NVARCHAR (100) NULL,
    [Address2]           NVARCHAR (50)  NULL,
    [Address3]           NVARCHAR (50)  NULL,
    [Postcode]           NVARCHAR (50)  NULL,
    [City]               NVARCHAR (50)  NULL,
    [CountryID]          INT            NULL,
    [DeliveryMonth]      INT            NULL,
    [UpdateDate]         NVARCHAR (50)  NULL,
    [Notes]              NTEXT          NULL,
    [Telephone]          NVARCHAR (50)  NULL,
    [Fax]                NVARCHAR (50)  NULL,
    [Email]              NVARCHAR (50)  NULL,
    [VAT]                FLOAT          NULL,
    [OrderID]            INT            NULL,
    [TotalValue]         FLOAT          NULL,
    [OfferedValue]       FLOAT          NULL,
    [PriceListItem]      BIT            NULL,
    [CookieID]           INT            NULL,
    [CustomerID]         INT            NULL,
    [LocalHostQuoteID]   INT            NULL,
    [Fixed]              BIT            NULL,
    [FixedOfferValue]    FLOAT          NULL,
    [ShippingCosts]      FLOAT          NULL,
    [Refsalesman]        NVARCHAR (50)  NULL,
    [OEM]                BIT            NULL,
    [BoatGenID]          INT            NULL,
    [DeliveryDate]       NVARCHAR (20)  NULL,
    [WorksOrderNumber2]  NVARCHAR (255) NULL,
    [StandardSailQuote]  BIT            NULL,
    [ISp]                FLOAT          NULL,
    [Spl]                FLOAT          NULL,
    [Ey]                 FLOAT          NULL,
    [Py]                 FLOAT          NULL,
    [PrivateCustomer]    BIT            NULL,
    [Stl]                FLOAT          NULL,
    [NewDeliveryAddress] BIT            NULL,
    [DealerComment]      NVARCHAR (MAX) NULL,
    [MeasurementID]      INT            NULL,
    [DelDate]            DATETIME       NULL,
    [DateCreate]         DATETIME       NULL,
    [DateUpdated]        DATETIME       NULL,
    [CutOnly]            BIT            NULL,
    [MembraneOnly]       BIT            NULL,
    [BoatRigGrpID]       INT            NULL
);

